<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Switch Port Consumption</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;height:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Port Consumption</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;border:1pt solid silver"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;height:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><crosstab horizontalPagination="true" name="Crosstab1" refQuery="Port Count by Speed">
			<crosstabCorner>
				<contents><textItem><dataSource><staticValue>All Ports Inventory</staticValue></dataSource></textItem></contents>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="xm"/>
					</defaultStyles>
				<CSS value="border-bottom:1pt solid white;border-right:1pt solid white"/></style>
			</crosstabCorner>
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;height:100%;border:1pt solid silver"/>
				<defaultStyles>
					<defaultStyle refStyle="xt"/>
				</defaultStyles>
			</style>
		<crosstabFactCell><contents><textItem><dataSource><cellValue/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="mv"/></defaultStyles></style></crosstabFactCell><crosstabRows><crosstabNode><crosstabNestedNodes><crosstabNode><crosstabNodeMembers><crosstabSpacer edgeLocation="s1">
			<contents>
				<textItem>
					<dataSource>
						<staticValue> </staticValue>
					</dataSource>
				</textItem>
			<textItem><dataSource><staticValue>Port Speed</staticValue></dataSource><style><CSS value="font-weight:bold"/></style></textItem></contents>
			
			<style>
				<defaultStyles>
					<defaultStyle refStyle="xs"/>
				</defaultStyles>
			<CSS value="background-color:white"/></style>
		</crosstabSpacer></crosstabNodeMembers></crosstabNode></crosstabNestedNodes><crosstabNodeMembers><crosstabSpacer edgeLocation="s2">
			<contents>
				<textItem>
					<dataSource>
						<staticValue> </staticValue>
					</dataSource>
				</textItem>
			<textItem><dataSource><staticValue>Vendor</staticValue></dataSource><style><CSS value="font-weight:bold"/></style></textItem></contents>
			
			<style>
				<defaultStyles>
					<defaultStyle refStyle="xs"/>
				</defaultStyles>
			<CSS value="background-color:white"/></style>
		</crosstabSpacer></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNestedNodes><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Port Speed" edgeLocation="e1"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="background-color:white"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabNestedNodes><crosstabNodeMembers><crosstabNodeMember refDataItem="Vendor" edgeLocation="e3"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="background-color:white"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabRows><crosstabColumns><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Port Count" edgeLocation="e2"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="background-color:white"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Port OK" edgeLocation="e4"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="background-color:white"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Port Error" edgeLocation="e5"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="background-color:white"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Port Inactive" edgeLocation="e6"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="background-color:white"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabColumns></crosstab></contents><style><CSS value="padding:5px;vertical-align:top"/></style></tableCell><tableCell><contents><crosstab horizontalPagination="true" name="Crosstab2" refQuery="Port Consumption">
			<crosstabCorner>
				<contents><textItem><dataSource><staticValue>Port Consumption</staticValue></dataSource></textItem></contents>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="xm"/>
					</defaultStyles>
				</style>
			</crosstabCorner>
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;height:100%;border:1pt solid silver"/>
				<defaultStyles>
					<defaultStyle refStyle="xt"/>
				</defaultStyles>
			</style>
		<crosstabFactCell><contents><textItem><dataSource><cellValue/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="mv"/></defaultStyles></style></crosstabFactCell><crosstabRows><crosstabNode><crosstabNestedNodes><crosstabNode><crosstabNodeMembers><crosstabSpacer edgeLocation="s1">
			<contents>
				<textItem>
					<dataSource>
						<staticValue> </staticValue>
					</dataSource>
				</textItem>
			<textItem><dataSource><staticValue>Port Speed</staticValue></dataSource><style><CSS value="font-weight:bold"/></style></textItem></contents>
			
			<style>
				<defaultStyles>
					<defaultStyle refStyle="xs"/>
				</defaultStyles>
			<CSS value="background-color:white"/></style>
		</crosstabSpacer></crosstabNodeMembers></crosstabNode></crosstabNestedNodes><crosstabNodeMembers><crosstabSpacer edgeLocation="s2">
			<contents>
				<textItem>
					<dataSource>
						<staticValue> </staticValue>
					</dataSource>
				</textItem>
			<textItem><dataSource><staticValue>Vendor</staticValue></dataSource><style><CSS value="font-weight:bold"/></style></textItem></contents>
			
			<style>
				<defaultStyles>
					<defaultStyle refStyle="xs"/>
				</defaultStyles>
			<CSS value="background-color:white"/></style>
		</crosstabSpacer></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNestedNodes><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Port Speed" edgeLocation="e2"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="white-space:nowrap;background-color:white"/></style><contents>
																											<textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabNestedNodes><crosstabNodeMembers><crosstabNodeMember refDataItem="Vendor" edgeLocation="e1"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="background-color:white"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabRows><crosstabColumns><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Traffic %" edgeLocation="e3"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="background-color:white"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Peak Traffic %" edgeLocation="e4"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="background-color:white"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabColumns><crosstabIntersections><crosstabIntersection row="e2" column="e3"><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 1"/></conditionalStyleRefs></crosstabIntersection><crosstabIntersection row="e2" column="e4"><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 2"/></conditionalStyleRefs></crosstabIntersection></crosstabIntersections></crosstab></contents><style><CSS value="vertical-align:top;padding-top:5px;padding-right:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><list horizontalPagination="true" name="List1" refQuery="Port Consumption">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Vendor"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Vendor"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><staticValue>Combination Chart</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles></style><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;height:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Peak Traffic %</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" orientation="horizontal" name="Combination Chart1" refQuery="Port Consumption" depth="9">
																									<v2_combinationTypeTooltips/>
																									<v2_commonAxis>
																										<v2_ordinalAxis>
																											<v2_axisLabels>
																												<style>
																													<defaultStyles>
																														<defaultStyle refStyle="al"/>
																													</defaultStyles>
																												<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###'%'"/></dataFormat></style>
																											</v2_axisLabels>
																										</v2_ordinalAxis>
																										<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Port Speed"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																									<v2_topLeftAxis>
																										<v2_combinationChartTypes>
																											<v2_bar barShape="box">
																												<v2_solidPalette>
																													<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																												<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Peak Traffic %"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###'%'"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_conditionalSolidPalette><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_specifiedLabel><defaultText>Peak Traffic &gt; 80%</defaultText></v2_specifiedLabel></v2_conditionalPaletteEntryLabel><reportCondition>[Port Consumption].[Peak Traffic %]&gt;80</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#FDCF9B"/></v2_fillEffect></v2_solidPaletteEntry></v2_conditionalCase></v2_conditionalCases></v2_advancedCondition></v2_conditionalSolidPalette><v2_chartDataLabels displayDataLocation="centered" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
																										</v2_combinationChartTypes>
																										<v2_axis>
																											<v2_axisRange>
																												<v2_automaticRange/>
																											</v2_axisRange>
																											<v2_axisLabels>
																												<style>
																													<defaultStyles>
																														<defaultStyle refStyle="al"/>
																													</defaultStyles>
																												<CSS value="color:#454545"/></style>
																											</v2_axisLabels>
																											<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																										</v2_axis>
																									</v2_topLeftAxis>
																									<style>
																										<defaultStyles>
																											<defaultStyle refStyle="ch"/>
																										</defaultStyles>
																										<CSS value="width:290px;height:200px;color:#333333"/></style>
																									<noDataHandler>
																										<contents>
																											<block>
																												<contents>
																													<textItem>
																														<dataSource>
																															<staticValue>No Data Available</staticValue>
																														</dataSource>
																														<style>
																															<CSS value="padding:10px 18px;"/>
																														</style>
																													</textItem>
																												</contents>
																											</block>
																										</contents>
																									</noDataHandler>
																									<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Vendor"/></masterContext><detailContext><dataItemContext refDataItem="Vendor"/></detailContext></masterDetailLink></masterDetailLinks><v2_legend>
																										<v2_legendPosition>
																											<v2_legendPreset legendPositionPreset="bottom"/>
																										</v2_legendPosition>
																										<style>
																											<defaultStyles>
																												<defaultStyle refStyle="lg"/>
																											</defaultStyles>
																										<CSS value="color:#454545"/></style>
																									</v2_legend>
																									</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table>
																							</contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><staticValue>Table</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="padding-left:5px"/></style><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;height:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Traffic %</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" orientation="horizontal" name="Combination Chart2" refQuery="Port Consumption" depth="9">
	<v2_combinationTypeTooltips/>
	<v2_commonAxis>
		<v2_ordinalAxis>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###'%'"/></dataFormat></style>
			</v2_axisLabels>
		</v2_ordinalAxis>
		<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Port Speed"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
	<v2_topLeftAxis>
		<v2_combinationChartTypes>
			<v2_bar barShape="box">
				<v2_solidPalette>
					<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
				<v2_conditionalSolidPalette><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><reportCondition>[Port Consumption].[Traffic %]&gt; 80 </reportCondition><v2_conditionalPaletteEntryLabel><v2_specifiedLabel><defaultText>Traffic &gt; 80%</defaultText></v2_specifiedLabel></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#FDCF9B"/></v2_fillEffect></v2_solidPaletteEntry></v2_conditionalCase></v2_conditionalCases></v2_advancedCondition></v2_conditionalSolidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Traffic %"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###'%'"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="centered" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
		</v2_combinationChartTypes>
		<v2_axis>
			<v2_axisRange>
				<v2_automaticRange/>
			</v2_axisRange>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<CSS value="color:#454545"/></style>
			</v2_axisLabels>
			<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
		</v2_axis>
	</v2_topLeftAxis>
	<style>
		<defaultStyles>
			<defaultStyle refStyle="ch"/>
		</defaultStyles>
		<CSS value="width:290px;height:200px;color:#333333"/></style>
	<noDataHandler>
		<contents>
			<block>
				<contents>
					<textItem>
						<dataSource>
							<staticValue>No Data Available</staticValue>
						</dataSource>
						<style>
							<CSS value="padding:10px 18px;"/>
						</style>
					</textItem>
				</contents>
			</block>
		</contents>
	</noDataHandler>
	<masterDetailLinks><masterDetailLink><masterContext><dataItemContext refDataItem="Vendor"/></masterContext><detailContext><dataItemContext refDataItem="Vendor"/></detailContext></masterDetailLink></masterDetailLinks><v2_legend>
		<v2_legendPosition>
			<v2_legendPreset legendPositionPreset="bottom"/>
		</v2_legendPosition>
		<style>
			<defaultStyles>
				<defaultStyle refStyle="lg"/>
			</defaultStyles>
		<CSS value="color:#454545"/></style>
	</v2_legend>
	</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="display:none"/></style><contents><textItem><dataSource><staticValue>Combination Chart</staticValue></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="padding-left:5px"/></style><contents/></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="padding-right:5px;padding-bottom:5px;padding-left:5px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;padding-bottom:5px"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;height:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Port Usage Trends</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Port Usage Trends" name="Combination Chart3">
																				<v2_combinationTypeTooltips/>
																				<v2_legend>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="color:#454545"/></style>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																				</v2_legend>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="yyyy-MM"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_line lineDisplayType="lineAndMarkers" lineAreaShape="smooth">
																							<v2_linePalette markerSize="5pt">
																								<v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#9ABCC3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#A8E3D7"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#88B2D3"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry><v2_lineFill defaultColor="#198545"><v2_color color="#FFB2C1"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette>
																							<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Ports"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used Ports"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_line>
																					</v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							<v2_automaticRange/>
																						</v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="color:#454545"/></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<CSS value="padding-top:5px;padding-left:5px;width:580px;height:415px"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_chartSubTitle refQuery="Port Usage Trends"><style><defaultStyles><defaultStyle refStyle="cs"/></defaultStyles><CSS value="text-align:left;color:gray;font-size:8pt"/></style><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>Data Center: All    Port Speed: All    Vendor: All</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems></v2_chartSubTitle></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;height:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Port Utilization</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;height:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Global Port Utilization</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_gaugeChart maxHotspots="10000" name="Gauge Chart3" refQuery="Current Port Utilization">
	<v2_basicTooltips/>
	<v2_gaugeAxes>
		<v2_gaugeAxis gaugeAxisEndAngle="300" gaugeAxisStartAngle="240">
			<v2_axisRange scale="linear">
				<v2_specifiedRange includeZeroForAutoScale="true" min="0" max="1"/></v2_axisRange>
			<v2_gaugeAxisLine lineWeight="0"/>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
					<CSS value="font-size:14pt;font-weight:bold"/><dataFormat><percentFormat/></dataFormat></style>
			</v2_axisLabels>
			<v2_gaugeAxisMajorGridlines gridlineColor="#000000" gridlineLength="15pt"/>
			<v2_gaugeNeedle needleHeadLength="70" needleHeadStyle="triangular" needleHeadWidth="3">
				<v2_solidPalette>
					<v2_solidPaletteEntries><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor color="#0084e3" transparency="20"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry>
																									<v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#000066"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry>
																									<v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#99CCFF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry>
																									<v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#336699"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry>
																									<v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry>
																									<v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry>
																									<v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#99AACC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry>
																									<v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#999999"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry>
																									<v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry>
																									<v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry>
																								</v2_solidPaletteEntries></v2_solidPalette>
				<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used %"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_gaugeNeedle>
			<v2_axisColors><v2_gradientColor gradientColor="#F95D5D" colorPosition="85"/><v2_gradientColor colorPosition="100" gradientColor="#F95D5D"/></v2_axisColors></v2_gaugeAxis>
	</v2_gaugeAxes>
	<style>
		<defaultStyles>
			<defaultStyle refStyle="ch"/>
		</defaultStyles>
		<CSS value="width:245px;height:270px"/></style>
	<noDataHandler>
		<contents>
			<block>
				<contents>
					<textItem>
						<dataSource>
							<staticValue>No Data Available</staticValue>
						</dataSource>
						<style>
							<CSS value="padding:10px 18px;"/>
						</style>
					</textItem>
				</contents>
			</block>
		</contents>
	</noDataHandler>
	<v2_dropShadow blurPreset="minimumBlur" color="black" shadowOffset="5px"/><v2_dialFace><v2_fillEffect><v2_linearGradient gradientAngle="180"><v2_gradientColor colorPosition="0" gradientColor="rgb(100,100,100)"/><v2_gradientColor colorPosition="100" gradientColor="white"/></v2_linearGradient></v2_fillEffect></v2_dialFace><v2_pivot pivotColor="#8DB4E2" pivotRadius="10" pivotBevelRadius="25" pivotBevelStyle="flat"/></v2_gaugeChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;height:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Port Utilization by Data Center</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_gaugeChart maxHotspots="10000" name="Gauge Chart4" refQuery="Current Port Utilization DC">
	<v2_basicTooltips/>
	<v2_gaugeAxes>
		<v2_gaugeAxis gaugeAxisEndAngle="300" gaugeAxisStartAngle="240">
			<v2_axisRange scale="linear">
				<v2_specifiedRange includeZeroForAutoScale="true" min="0" max="1"/></v2_axisRange>
			<v2_gaugeAxisLine lineWeight="0"/>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
					<CSS value="font-size:14pt;font-weight:bold"/><dataFormat><percentFormat/></dataFormat></style>
			</v2_axisLabels>
			<v2_gaugeAxisMajorGridlines gridlineColor="#000000" gridlineLength="15pt"/>
			<v2_gaugeNeedle needleHeadLength="70" needleHeadStyle="triangular" needleHeadWidth="3">
				<v2_solidPalette>
					<v2_solidPaletteEntries><v2_solidPaletteEntry>
							<v2_fillEffect defaultColor="#0084e3">
								<v2_solidColor color="#0084e3" transparency="20"/>
							</v2_fillEffect>
						</v2_solidPaletteEntry>
						<v2_solidPaletteEntry>
							<v2_fillEffect defaultColor="#000066">
								<v2_solidColor color="#000066"/>
							</v2_fillEffect>
						</v2_solidPaletteEntry>
						<v2_solidPaletteEntry>
							<v2_fillEffect defaultColor="#99CCFF">
								<v2_solidColor color="#99CCFF"/>
							</v2_fillEffect>
						</v2_solidPaletteEntry>
						<v2_solidPaletteEntry>
							<v2_fillEffect defaultColor="#336699">
								<v2_solidColor color="#336699"/>
							</v2_fillEffect>
						</v2_solidPaletteEntry>
						<v2_solidPaletteEntry>
							<v2_fillEffect defaultColor="#F3F3F3">
								<v2_solidColor color="#F3F3F3"/>
							</v2_fillEffect>
						</v2_solidPaletteEntry>
						<v2_solidPaletteEntry>
							<v2_fillEffect defaultColor="#E7E7E7">
								<v2_solidColor color="#E7E7E7"/>
							</v2_fillEffect>
						</v2_solidPaletteEntry>
						<v2_solidPaletteEntry>
							<v2_fillEffect defaultColor="#99AACC">
								<v2_solidColor color="#99AACC"/>
							</v2_fillEffect>
						</v2_solidPaletteEntry>
						<v2_solidPaletteEntry>
							<v2_fillEffect defaultColor="#999999">
								<v2_solidColor color="#999999"/>
							</v2_fillEffect>
						</v2_solidPaletteEntry>
						<v2_solidPaletteEntry>
							<v2_fillEffect defaultColor="#E3E9F3">
								<v2_solidColor color="#E3E9F3"/>
							</v2_fillEffect>
						</v2_solidPaletteEntry>
						<v2_solidPaletteEntry>
							<v2_fillEffect defaultColor="#CCCCCC">
								<v2_solidColor color="#CCCCCC"/>
							</v2_fillEffect>
						</v2_solidPaletteEntry>
					</v2_solidPaletteEntries></v2_solidPalette>
				<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used %"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_gaugeNeedle>
			<v2_axisColors><v2_gradientColor gradientColor="#F95D5D" colorPosition="85"/><v2_gradientColor colorPosition="100" gradientColor="#F95D5D"/></v2_axisColors></v2_gaugeAxis>
	</v2_gaugeAxes>
	<style>
		<defaultStyles>
			<defaultStyle refStyle="ch"/>
		</defaultStyles>
		<CSS value="width:400px;height:270px"/></style>
	<noDataHandler>
		<contents>
			<block>
				<contents>
					<textItem>
						<dataSource>
							<staticValue>No Data Available</staticValue>
						</dataSource>
						<style>
							<CSS value="padding:10px 18px;"/>
						</style>
					</textItem>
				</contents>
			</block>
		</contents>
	</noDataHandler>
	<v2_dropShadow blurPreset="minimumBlur" color="black" shadowOffset="5px"/><v2_dialFace><v2_fillEffect><v2_linearGradient gradientAngle="180"><v2_gradientColor colorPosition="0" gradientColor="rgb(100,100,100)"/><v2_gradientColor colorPosition="100" gradientColor="white"/></v2_linearGradient></v2_fillEffect></v2_dialFace><v2_category><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Data Center"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_category><v2_matrix><v2_matrixColumns matrixLevels="1"><v2_matrixColumnLabels><style><defaultStyles><defaultStyle refStyle="al"/></defaultStyles></style></v2_matrixColumnLabels><v2_axisTitle refQuery="Current Port Utilization DC"><style><defaultStyles><defaultStyle refStyle="at"/></defaultStyles></style><v2_chartTextContents><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue/></dataSource></v2_chartTextItem></v2_chartTextItems></v2_chartTextContents></v2_axisTitle></v2_matrixColumns></v2_matrix><XMLAttributes><XMLAttribute name="titlesExpanded" value="true" output="no"/></XMLAttributes><v2_pivot pivotColor="#8DB4E2" pivotRadius="10" pivotBevelRadius="25" pivotBevelStyle="flat"/></v2_gaugeChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;padding-top:5px;padding-bottom:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;height:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Ports by Physical Switch</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><v2_combinationChart maxHotspots="10000" refQuery="Switch Fabric" name="Combination Chart4" depth="9">
																				<v2_combinationTypeTooltips/>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					</style>
																				</v2_legend>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="color:#454545"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Switch Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_bar setOrdinalWidthScale="80" bevel="none" borderColor="black" barShape="box">
																							<v2_solidPalette>
																								<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																							<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Ports"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used Ports"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="centered" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
																					</v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							<v2_automaticRange/>
																						</v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="color:#454545"/></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<CSS value="width:590px;height:295px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				</v2_combinationChart>
																		</contents><style><CSS value="padding:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;padding-bottom:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px;padding-bottom:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>7.7 Switch Port Consumption</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><queries><query name="Port Count by Speed">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_performance" type="passThrough">
			<sqlText>
SELECT
dwh_inventory.switch.manufacturer as 'Vendor',
dwh_inventory.switch_port.speed as 'Port Speed',
COUNT(DISTINCT dwh_inventory.switch_port.id) as 'Port Count',
SUM(IF(dwh_inventory.switch_port.status='OK',1, 0)) as 'Port OK',
SUM(IF(dwh_inventory.switch_port.status='ERROR',1, 0)) as 'Port Error',
SUM(IF(dwh_inventory.switch_port.status='INACTIVE',1, 0)) as 'Port Inactive'

FROM dwh_inventory.switch_port
JOIN dwh_inventory.switch
ON dwh_inventory.switch.id=dwh_inventory.switch_port.switchid

WHERE dwh_inventory.switch_port.speed is not null

GROUP BY dwh_inventory.switch.manufacturer, dwh_inventory.switch_port.speed </sqlText>
		<mdProjectedItems><mdProjectedItem name="Vendor"/><mdProjectedItem name="Port Speed"/><mdProjectedItem name="Port Count"/><mdProjectedItem name="Port OK"/><mdProjectedItem name="Port Error"/><mdProjectedItem name="Port Inactive"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Vendor"><expression>[SQL2].[Vendor]</expression></dataItem><dataItem name="Port Speed"><expression>[SQL2].[Port Speed]</expression></dataItem><dataItem name="Port Count" aggregate="total"><expression>[SQL2].[Port Count]</expression></dataItem><dataItem name="Port OK" aggregate="total"><expression>[SQL2].[Port OK]</expression></dataItem><dataItem name="Port Error" aggregate="total"><expression>[SQL2].[Port Error]</expression></dataItem><dataItem name="Port Inactive" aggregate="total"><expression>[SQL2].[Port Inactive]</expression></dataItem></selection>
		</query><query name="Port Consumption">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT
dwh_performance.switch_dimension.manufacturer as 'Vendor',
dwh_performance.port_dimension.speed as 'Port Speed',
COUNT(distinct dwh_performance.port_dimension.tk) as 'Port Count',
ROUND(MAX(dwh_performance.switch_performance_for_port_hourly_fact.trafficUtilizationTotal),2) as 'Traffic %', 
ROUND(MAX(dwh_performance.switch_performance_for_port_hourly_fact.trafficUtilizationTotalMax),2) as 'Peak Traffic %'

FROM dwh_performance.switch_performance_for_port_hourly_fact
JOIN dwh_performance.port_dimension
ON dwh_performance.port_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.porttk
AND dwh_performance.port_dimension.latest=1
JOIN dwh_performance.switch_dimension
ON dwh_performance.switch_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.switchtk
JOIN dwh_performance.time_dimension
ON dwh_performance.time_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.timetk

WHERE dwh_performance.port_dimension.speed is not null

GROUP BY dwh_performance.switch_dimension.manufacturer, dwh_performance.port_dimension.speed
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Vendor"/><mdProjectedItem name="Port Speed"/><mdProjectedItem name="Port Count"/><mdProjectedItem name="Traffic %"/><mdProjectedItem name="Peak Traffic %"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Vendor"><expression>[SQL1].[Vendor]</expression></dataItem><dataItem name="Port Speed"><expression>[SQL1].[Port Speed]</expression></dataItem><dataItem name="Port Count"><expression>[SQL1].[Port Count]</expression></dataItem><dataItem name="Traffic %" aggregate="maximum"><expression>[SQL1].[Traffic %]</expression></dataItem><dataItem name="Peak Traffic %" aggregate="maximum"><expression>[SQL1].[Peak Traffic %]</expression></dataItem></selection>
		</query><query name="Port Usage Trends"><source><sqlQuery name="SQL3" dataSource="dwh_ports" type="passThrough">
			<sqlText>SELECT
COUNT(distinct dwh_ports.ports_fact.porttk) as 'Total Ports',
SUM(IF(dwh_ports.ports_fact.status='OK',1,0)) as 'Used Ports',
dwh_ports.date_dimension.fulldate as 'Full Date'

FROM dwh_ports.ports_fact
JOIN dwh_ports.date_dimension
ON dwh_ports.date_dimension.tk=dwh_ports.ports_fact.datetk
JOIN dwh_ports.port_dimension
ON dwh_ports.port_dimension.tk=dwh_ports.ports_fact.porttk
JOIN dwh_ports.switch_dimension
ON dwh_ports.switch_dimension.tk=dwh_ports.ports_fact.switchtk
AND dwh_ports.switch_dimension.npv = 0
AND dwh_ports.ports_fact.status&lt;&gt;'NOT_LICENSED'
AND dwh_ports.port_dimension.id NOT IN (SELECT dwh_ports.port_dimension.id FROM dwh_ports.port_dimension WHERE dwh_ports.port_dimension.gbicType LIKE '%ICL%')
AND dwh_ports.port_dimension.name NOT LIKE '%vfc%'
AND dwh_ports.date_dimension.repmonthorlatest=1

GROUP BY dwh_ports.date_dimension.tk
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Total Ports"/><mdProjectedItem name="Used Ports"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Total Ports" aggregate="total"><expression>[SQL3].[Total Ports]</expression></dataItem><dataItem name="Used Ports" aggregate="total"><expression>[SQL3].[Used Ports]</expression></dataItem><dataItem name="Full Date"><expression>[SQL3].[Full Date]</expression></dataItem></selection></query><query name="Current Port Utilization">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_ports" type="passThrough">
			<sqlText>SELECT
dwh_ports.switch_dimension.datacenter as 'Data Center',
COUNT(distinct dwh_ports.ports_fact.porttk) as 'Total Ports',
SUM(IF(dwh_ports.ports_fact.status='OK',1,0)) as 'Used Ports',
dwh_ports.date_dimension.fulldate as 'Full Date'

FROM dwh_ports.ports_fact
JOIN dwh_ports.switch_dimension
ON dwh_ports.switch_dimension.tk=dwh_ports.ports_fact.switchtk
JOIN dwh_ports.date_dimension
ON dwh_ports.date_dimension.tk=dwh_ports.ports_fact.datetk
AND dwh_ports.date_dimension.latest=1

GROUP BY dwh_ports.switch_dimension.datacenter, dwh_ports.date_dimension.tk</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Total Ports"/><mdProjectedItem name="Used Ports"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Total Ports" aggregate="total"><expression>[SQL4].[Total Ports]</expression></dataItem><dataItem name="Used Ports" aggregate="total"><expression>[SQL4].[Used Ports]</expression></dataItem><dataItem name="Used %"><expression>[Used Ports]/[Total Ports]</expression></dataItem><dataItem name="Data Center"><expression>[SQL4].[Data Center]</expression></dataItem></selection>
		</query><query name="Current Port Utilization DC">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_ports" type="passThrough">
			<sqlText>SELECT
dwh_ports.switch_dimension.datacenter as 'Data Center',
COUNT(distinct dwh_ports.ports_fact.porttk) as 'Total Ports',
SUM(IF(dwh_ports.ports_fact.status='OK',1,0)) as 'Used Ports',
dwh_ports.date_dimension.fulldate as 'Full Date'

FROM dwh_ports.ports_fact
JOIN dwh_ports.switch_dimension
ON dwh_ports.switch_dimension.tk=dwh_ports.ports_fact.switchtk
JOIN dwh_ports.date_dimension
ON dwh_ports.date_dimension.tk=dwh_ports.ports_fact.datetk
AND dwh_ports.date_dimension.latest=1

GROUP BY dwh_ports.switch_dimension.datacenter, dwh_ports.date_dimension.tk</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Total Ports"/><mdProjectedItem name="Used Ports"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Total Ports" aggregate="total"><expression>[SQL4].[Total Ports]</expression></dataItem><dataItem name="Used Ports" aggregate="total"><expression>[SQL4].[Used Ports]</expression></dataItem><dataItem name="Used %"><expression>[Used Ports]/[Total Ports]</expression></dataItem><dataItem name="Data Center"><expression>[SQL4].[Data Center]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Data Center]&lt;&gt;'N/A'</filterExpression></detailFilter></detailFilters></query><query name="Switch Fabric">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
*
FROM
(
SELECT
dwh_inventory.switch.name as 'Switch Name',
dwh_inventory.switch.id as 'switchid',
dwh_inventory.switch.ip as 'IP',
dwh_inventory.switch.manufacturer as 'Vendor',
dwh_inventory.switch.model as 'Model',
dwh_inventory.switch.firmware as 'Firmware',
dwh_inventory.switch.serialnumber as 'Serial Number',
IF(dwh_inventory.switch.active=1,'OK','INACTIVE') as 'Status',
dwh_inventory.switch.type as 'Type',
dwh_inventory.switch.datacenter as 'Data Center'

FROM dwh_inventory.switch

GROUP BY dwh_inventory.switch.id ) X

LEFT JOIN

(
SELECT
	dwh_inventory.switch.id as sid,
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'Total Ports'
FROM	dwh_inventory.switch_port 
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
-- AND	dwh_inventory.switch.npv = 0
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND              dwh_inventory.switch.id=switchid

GROUP BY dwh_inventory.switch.id ) Y ON Y.sid=X.switchid

LEFT JOIN

(SELECT 	
	dwh_inventory.switch.id as 'usid',
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'Used Ports'
FROM	dwh_inventory.switch_port
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
-- AND	dwh_inventory.switch.npv = 0
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND	dwh_inventory.switch_port.id IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)

GROUP BY dwh_inventory.switch.id ) YY ON YY.usid=X.switchid

LEFT JOIN

(
SELECT 	
	dwh_inventory.switch.id as 'fsid',
	COUNT(DISTINCT dwh_inventory.switch_port.id) AS 'Free Ports'
FROM	dwh_inventory.switch_port
JOIN	dwh_inventory.switch
ON	dwh_inventory.switch_port.switchId = dwh_inventory.switch.id
-- AND	dwh_inventory.switch.npv = 0
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.switch_port.id FROM dwh_inventory.switch_port WHERE dwh_inventory.switch_port.gbicType LIKE '%ICL%')
AND	dwh_inventory.switch_port.active = 1
AND	dwh_inventory.switch_port.status &lt;&gt; 'NOT_LICENSED'
AND	dwh_inventory.switch_port.name NOT LIKE '%vfc%'
AND	dwh_inventory.switch_port.id NOT IN (SELECT dwh_inventory.port_connectivity.portId FROM dwh_inventory.port_connectivity)

GROUP BY dwh_inventory.switch.id) YYY ON YYY.fsid=X.switchid



</sqlText>
		<mdProjectedItems><mdProjectedItem name="Switch Name"/><mdProjectedItem name="switchid"/><mdProjectedItem name="IP"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Model"/><mdProjectedItem name="Firmware"/><mdProjectedItem name="Serial Number"/><mdProjectedItem name="Status"/><mdProjectedItem name="Type"/><mdProjectedItem name="Data Center"/><mdProjectedItem name="sid"/><mdProjectedItem name="Total Ports"/><mdProjectedItem name="usid"/><mdProjectedItem name="Used Ports"/><mdProjectedItem name="fsid"/><mdProjectedItem name="Free Ports"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Switch Name"><expression>[SQL5].[Switch Name]</expression></dataItem><dataItem name="IP"><expression>[SQL5].[IP]</expression></dataItem><dataItem name="Vendor"><expression>[SQL5].[Vendor]</expression></dataItem><dataItem name="Model"><expression>[SQL5].[Model]</expression></dataItem><dataItem name="Firmware"><expression>[SQL5].[Firmware]</expression></dataItem><dataItem name="Serial Number"><expression>[SQL5].[Serial Number]</expression></dataItem><dataItem name="Status"><expression>[SQL5].[Status]</expression></dataItem><dataItem name="Type"><expression>[SQL5].[Type]</expression></dataItem><dataItem name="Data Center"><expression>[SQL5].[Data Center]</expression></dataItem><dataItem name="Total Ports" aggregate="total"><expression>[SQL5].[Total Ports]</expression></dataItem><dataItem name="Used Ports" aggregate="total"><expression>[SQL5].[Used Ports]</expression></dataItem><dataItem name="Free Ports"><expression>[SQL5].[Free Ports]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Type]='CHASSIS'</filterExpression></detailFilter></detailFilters></query></queries><namedConditionalStyles><advancedConditionalStyle name="Conditional Style 1"><styleCases><styleCase><style><CSS value="background-color:#FDCF9B;color:black"/></style><reportCondition>[Port Consumption].[Traffic %]&gt;80</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle><advancedConditionalStyle name="Conditional Style 2"><styleCases><styleCase><style><CSS value="background-color:#FDCF9B;color:black"/></style><reportCondition>[Port Consumption].[Peak Traffic %]&gt;80</reportCondition></styleCase></styleCases><styleDefault/></advancedConditionalStyle></namedConditionalStyles></report>